CREATE TABLE [dbo].[AccountInfo]
(
[Id] [uniqueidentifier] NOT NULL,
[ServiceInfoId] [uniqueidentifier] NOT NULL,
[Login] [varbinary] (max) NOT NULL,
[Password] [varbinary] (max) NOT NULL,
[Email] [varbinary] (max) NULL,
[FirstName] [varbinary] (max) NULL,
[LastName] [varbinary] (max) NULL,
[SecretQuestion] [varbinary] (max) NULL,
[SecretAnswer] [varbinary] (max) NULL,
[MobilePhone] [varbinary] (max) NULL,
[ShortId] [varbinary] (max) NULL,
[AdditionalInfo] [varbinary] (max) NULL,
[DateCreated] [datetime] NOT NULL,
[Deleted] [bit] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
ALTER TABLE [dbo].[AccountInfo] ADD
CONSTRAINT [FK_AccountInfo_ServiceInfo] FOREIGN KEY ([ServiceInfoId]) REFERENCES [dbo].[ServiceInfo] ([Id])
GO
ALTER TABLE [dbo].[AccountInfo] ADD CONSTRAINT [PK_AccountInfo] PRIMARY KEY CLUSTERED  ([Id]) ON [PRIMARY]
GO
